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.
N6842JOracle Aviation LLC · Omaha, NEN6842UThompson Matthew S · Fowler, CON6843HWhitefish Mountain Acft Rentals And Flt School LLC · Whitefish, MTN6843UBoone Joe · Madison, INN6843WRhodes Michael J · Fresno, CAN6844JHundshamer Sara M · Smithfield, UTN6844KNoguess Levi B · Belton, TXN68459Airplanes And Helicopters Of Oregon LLC · Sisters, ORN6845BShrode Rafe C · Jewett, TXN6845KGottfried Virgil P · Wilkesboro, NCN6845NTriplett Jared · Mckinnon, WYN6845UTarrant James D · Wenatchee, WAN6845ZBr Trucking LLC · Cut Bank, MTN68460Registration Pending · Sheridan, WYRegistration pendingN6846NBitcertificates LLC · Kalispell, MTN6846UStokely Nicholas J · Wagram, NCN68475California In Nice Inc · San Jose, CAN68477Freiburger Thomas M · Belvedere, CAN6847BOtt Grosvenor LLC · Dillingham, AKN6847DPietron Spraying Inc · Larimore, NDN6847JMarkle Rick S · Waddy, KYN6847KWilson Galen B · Belchertown, MAN6847UFolkerts Thomas A · Roseville, CAN68485Dkg Cessna LLC · Flagler Beach, FLN68488Tomeny Aero Inc · Florence, ORN6848BPainter William L · Salem, VAN6848JPrudent Paths LLC · Hillsborough, CAN6848NWinner William B · Durango, CON6848UKiefer Nathaniel Stephen · Del Rio, TXN68490Chersky Brian · Santa Maria, CAN68499Sheboygan Survey LLC · Waldo, WIN6849BWeeks Vaughan B · Racine, WIN6849JSecker David A · San Jose, CAFirst renewal noticeN6849NBig Bad Technology LLC · Hawthorne, FLN6849UShipman Terry · Flossmoor, ILN684APiper Archer Three LLC · Wilmington, DEN684ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN684DWSun Aircraft Management LLC · Ormond Beach, FLN684FLRegistration Pending · Odenton, MDRegistration pendingN684KWFour Kilo Whiskey LLC · Key West, FLN684LHChristiansen Aviation LLC · Wilmington, DEN684LVVassberg Eric · Aledo, TXN684NDUnd Aerospace Foundation · Grand Forks, NDN684RAArendale Richard O · Hattiesburg, MSN684RWWarren Randal W · Pine Bluff, ARN684SKShearer Gregory L · Avon, INN684SPCondor Aero Club Inc · Zelienople, PAN68500Air Dakota Flite Inc · Hettinger, NDN68504US Liberty Holdings LLC · Caldwell, IDN68505Volara Aviation LLC · Glendale, AZ
Back to AD 90-04-06 R1