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.
N49325Qualiair LLC Trustee · MichelstadtN49328Air Puerto Rico Corp · Aguadilla, PRFirst renewal noticeN4932JDunlap Aviation Inc · Dunlap, ILN4932ZWilczynski John J · Lake Village, INN49330Cjw Hydrodynamics Inc · Fresno, TXN49331Plane Fun Inc Tr Trustee · Snellville, GAN49332Blue Eagle Pitts LLC · Tempe, AZN49336Krieger Heinz Friedrich · FrenkendorfN49337Herrmann Ralf D · DahlemN49338Bakker Matthew G · Ellington, CTN49339Goble John H · Cresson, TXN4933JRegistration Pending · Columbia, SCRegistration pending, pending cancellationN4933LSouthall Charles B · Amelia, OHN4933ZSale Reported · Clio, MISale reportedN49340Butler Tracey D · Buckley, WAN49341Dale Michael E · Murrieta, CAN49343Schroeder James Conrad · Redondo Beach, CAN49347Bryant Otto LLC · Conway, ARN49348Benner Tristen · Opheim, MTN49349Rankin Ty · Amarillo, TXN4934FAffordale Aviation Corp · Moriches, NYN4934LFlyboys LLC · Orange, VAN49353Skye Equipment LLC · Asheboro, NCN49354Staple Three Sheep Co · Midwest, WYN49357Miller Blaine Nathan · Brooks, GAN4935GKip'S Flying Service LLC · Bankston, ALN4935LCurnutt Aviation LLC · Fort Stockton, TXN49362Schubert Paul · Raleigh, NCN49363Back Country Aviation LLC · Kalispell, MTN49365Mcdonald Ryan James · Chelan, WAN49366Kellogg John H · Skaneateles, NYN4936LBluse James · Bethlehem, GAN4936ZDomeyer Daylen K · Cincinnati, OHN49370Powell Weston G · Washoe Valley, NVN49371Hebert Max C · Hartstown, PAN49372Walker Scott E · Fort Collins, CON4937FRegistered aircraftN4937GInternational Air Services Inc Trustee · Carson City, NVN4937PMorcom Aviation Services Inc · Everett, WAN49387Old Aire LLC · Bellingham, WAN4938HAir Poueir LLC · Amarillo, TXN4939LNorcross Tracy D · Saint Joseph, MON4939VFlorida Keys Flight Academy LLC · Marathon, FLN493BTRegistration Pending · Deltona, FLRegistration pendingN493CKTaylor Mark Steven · Goshen, OHN493DSDelaware State University · Dover, DEN493DWWayman Daniel M · Medford, ORN493FLPalmenteri Louis J · Rhome, TXN493GCClayton Neil K · Oviedo, FLFirst renewal noticeN493JLPhoenix Flyers Inc · Mesa, AZ
Back to AD 90-04-06 R1