AD 90-04-06 R1
Registered aircraft · 68,377
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N5155ZTowe Billy Joe Jr · Decatur, ALN5156HIndigenous Peoples Technology & Education Center · Dunnellon, FLN5156JWings Over La Aviation LLC · West Hills, CAN5156RKookaburra Kiwi LLC · Post Falls, IDN5156SKnopf Kenneth E · Charleston, WVN5156WJohnson James E · Hammond, LAN5156XHorton Kelly · Hollis, OKN5157HSchwend Brian · Forsyth, MTN5157KWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN5157SRegistration Pending · Anchorage, AKRegistration pendingN51580Middletown Regional Flight Training Institute LLC · Middletown, OHN51582Flight School Of Gwinnett Inc · Lawrenceville, GAFirst renewal noticeN5158EHuettl Austin · Liberty Hill, TXN5158HWestern Antique Aeroplane & Automobile Museum · Hood River, ORN5158LMichael J Baker · Clearwater, FLN5158MLenox Jeffrey D · Livingston, TXN5158QAnglin Cheryl · Jackson, MSN5158RBrandenburg Idu LLC · Brenham, TXN5158WMoniz Benjamin James · Brooklyn, NYN5158XSchnell Troy A · Alliance, NEN51594Candace A Larned Enterprises Inc · Long Beach, CAN51598Morgan Christopher D · Ogden, UTN5159EStraight Gary D · Wasilla, AKN5159HH&H Restoration LLC · Wasilla, AKN5159MThunder Wings LLC · Wilmington, DEN5159SDupre Richard H · Newton, NHN5159TSvggp LLC · Carnation, WAN5159UPostolnikov Paul V · Graham, WAN5159WZvirzdinis Jeffrey J · Lowell, MIN5159ZSiegel Scott A · Inez, KYN515AJDantonio Alfred · Tallahassee, FLN515DBSmith Christopher Robert · Snowflake, AZN515DFEralet Inc · Middletown, DEN515DGGatlin David T · Wickenburg, AZN515EDBlue Sky Pilots Inc · Salem, ORN515HWade Robert L · Orchard Park, NYN515JDSmith Michael K · Grass Valley, CAN515JFMedtek Inc · Racine, WIN515JHA&J Aircraft Leasing Inc · Burlington, CON515KCDeland Michael · Irvine, CAN515KGBatsche George M · Tampa, FLN515MDPodlesny Joseph F Jr · Glenmoore, PAN515MSDraco Flight School DBA · Chino, CAN515PHGulf Coast Helicopters Inc · Pearland, TXN515PUAviation Trust Co LLC Trustee · Oklahoma City, OKN515RDWings Over Texas Holdings LLC · Denton, TXN515SDHoma Alex Michael · Ozark, ALN515SKTurner Jereme K · Marietta, GAN515SPFriedlander Ernest · San Francisco, CAN515SRGifford Daniel · Fredericksburg, TX
Back to AD 90-04-06 R1